/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package eproject_sem2;

import javax.swing.JInternalFrame;

/**
 *
 * @author h
 */
public class Enquiry extends javax.swing.JFrame {

    ConnectSQL a = new ConnectSQL();
    VotesSent_Sever s = new VotesSent_Sever();
    static String EB = null;

    public static String getEB() {
        return EB;
    }

    public JInternalFrame getItnfStatusTT() {
        return itnfStatusTT;
    }

    /**
     * Creates new form Enquiry
     */
    public Enquiry() {
        initComponents();
        a.ShowTable(tableListBill, "", "Waybill", "Date", "StatusTT", "StatusVH", "EmployeeIDGN", "EmployeeIDKT", "All", "All", "All");


    }

    /**
     * This method is called from within the constructor to initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is always
     * regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {

        itnfStatusTT = new javax.swing.JInternalFrame();
        jpStatus = new javax.swing.JPanel();
        jSPTable = new javax.swing.JScrollPane();
        tableListBill = new javax.swing.JTable();
        btnView = new javax.swing.JButton();
        cBoxStt = new javax.swing.JComboBox();
        cBoxDay = new javax.swing.JComboBox();
        jLabel4 = new javax.swing.JLabel();
        jLabel5 = new javax.swing.JLabel();
        jLabel6 = new javax.swing.JLabel();
        cBoxMonth = new javax.swing.JComboBox();
        cBoxYear = new javax.swing.JComboBox();
        jLabel7 = new javax.swing.JLabel();
        jLabel8 = new javax.swing.JLabel();
        jpTotal = new javax.swing.JPanel();
        jLabel2 = new javax.swing.JLabel();
        jLabel3 = new javax.swing.JLabel();
        txtMoney = new javax.swing.JTextField();
        txtBills = new javax.swing.JTextField();
        jLabel9 = new javax.swing.JLabel();
        jpUpdateStatus = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();
        txtBillId = new javax.swing.JTextField();
        cBoxSttPay = new javax.swing.JComboBox();
        btnUpdatePay = new javax.swing.JButton();
        btnShowBill = new javax.swing.JButton();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

        itnfStatusTT.setClosable(true);
        itnfStatusTT.setVisible(true);

        jpStatus.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createEtchedBorder(), "Information"));

        tableListBill.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {},
                {},
                {},
                {}
            },
            new String [] {

            }
        ));
        tableListBill.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                tableListBillMouseClicked(evt);
            }
        });
        jSPTable.setViewportView(tableListBill);

        btnView.setText("View");
        btnView.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnViewActionPerformed(evt);
            }
        });

        cBoxStt.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "ALL", "Unpaid", "Completed", "Still", "Pending", "Compete" }));

        cBoxDay.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "ALL", "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31" }));
        cBoxDay.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cBoxDayActionPerformed(evt);
            }
        });

        jLabel4.setText("Day:");

        jLabel5.setText("Month");

        jLabel6.setText("Year:");

        cBoxMonth.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "All", "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12" }));
        cBoxMonth.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cBoxMonthActionPerformed(evt);
            }
        });

        cBoxYear.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "All", "2013", "2012", "2011", "2010", "2009", "2008", "2007" }));
        cBoxYear.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cBoxYearActionPerformed(evt);
            }
        });

        jLabel7.setText("Chose Status:");

        jLabel8.setText("Chose time:");

        javax.swing.GroupLayout jpStatusLayout = new javax.swing.GroupLayout(jpStatus);
        jpStatus.setLayout(jpStatusLayout);
        jpStatusLayout.setHorizontalGroup(
            jpStatusLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jpStatusLayout.createSequentialGroup()
                .addGroup(jpStatusLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jpStatusLayout.createSequentialGroup()
                        .addContainerGap()
                        .addComponent(jSPTable))
                    .addGroup(jpStatusLayout.createSequentialGroup()
                        .addGap(36, 36, 36)
                        .addComponent(jLabel7)
                        .addGap(18, 18, 18)
                        .addComponent(cBoxStt, javax.swing.GroupLayout.PREFERRED_SIZE, 134, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(125, 125, 125)
                        .addComponent(jLabel8)
                        .addGap(18, 18, 18)
                        .addComponent(jLabel4)
                        .addGap(15, 15, 15)
                        .addComponent(cBoxDay, javax.swing.GroupLayout.PREFERRED_SIZE, 62, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addComponent(jLabel5)
                        .addGap(12, 12, 12)
                        .addComponent(cBoxMonth, javax.swing.GroupLayout.PREFERRED_SIZE, 67, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addComponent(jLabel6)
                        .addGap(18, 18, 18)
                        .addComponent(cBoxYear, javax.swing.GroupLayout.PREFERRED_SIZE, 66, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(18, 18, 18)
                        .addComponent(btnView, javax.swing.GroupLayout.PREFERRED_SIZE, 64, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(0, 17, Short.MAX_VALUE)))
                .addContainerGap())
        );
        jpStatusLayout.setVerticalGroup(
            jpStatusLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jpStatusLayout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jpStatusLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(cBoxStt, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel7)
                    .addComponent(jLabel8)
                    .addComponent(cBoxDay, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel4)
                    .addComponent(cBoxMonth, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel5)
                    .addComponent(jLabel6)
                    .addComponent(cBoxYear, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(btnView, javax.swing.GroupLayout.PREFERRED_SIZE, 36, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jSPTable, javax.swing.GroupLayout.DEFAULT_SIZE, 193, Short.MAX_VALUE)
                .addGap(37, 37, 37))
        );

        jpTotal.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createEtchedBorder(), "Total"));

        jLabel2.setText("Total bill:");

        jLabel3.setText("Total money:");

        txtMoney.setEditable(false);

        txtBills.setEditable(false);

        jLabel9.setText("000vnd");

        javax.swing.GroupLayout jpTotalLayout = new javax.swing.GroupLayout(jpTotal);
        jpTotal.setLayout(jpTotalLayout);
        jpTotalLayout.setHorizontalGroup(
            jpTotalLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jpTotalLayout.createSequentialGroup()
                .addGap(41, 41, 41)
                .addGroup(jpTotalLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(jLabel2)
                    .addComponent(jLabel3))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 51, Short.MAX_VALUE)
                .addGroup(jpTotalLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addComponent(txtBills, javax.swing.GroupLayout.DEFAULT_SIZE, 165, Short.MAX_VALUE)
                    .addComponent(txtMoney))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addComponent(jLabel9)
                .addGap(15, 15, 15))
        );
        jpTotalLayout.setVerticalGroup(
            jpTotalLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jpTotalLayout.createSequentialGroup()
                .addGap(14, 14, 14)
                .addGroup(jpTotalLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 14, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(txtBills, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(25, 25, 25)
                .addGroup(jpTotalLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel3)
                    .addComponent(txtMoney, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel9))
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

        jpUpdateStatus.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createEtchedBorder(), "Update Status"));

        jLabel1.setText("Bill ID :");

        txtBillId.setEditable(false);
        txtBillId.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                txtBillIdActionPerformed(evt);
            }
        });

        cBoxSttPay.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Unpaid", "Completed" }));

        btnUpdatePay.setText("OK");
        btnUpdatePay.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnUpdatePayActionPerformed(evt);
            }
        });

        btnShowBill.setText("Show bill");
        btnShowBill.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnShowBillActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout jpUpdateStatusLayout = new javax.swing.GroupLayout(jpUpdateStatus);
        jpUpdateStatus.setLayout(jpUpdateStatusLayout);
        jpUpdateStatusLayout.setHorizontalGroup(
            jpUpdateStatusLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jpUpdateStatusLayout.createSequentialGroup()
                .addGap(0, 0, Short.MAX_VALUE)
                .addComponent(btnUpdatePay)
                .addGap(185, 185, 185))
            .addGroup(jpUpdateStatusLayout.createSequentialGroup()
                .addGap(29, 29, 29)
                .addComponent(jLabel1)
                .addGap(18, 18, 18)
                .addGroup(jpUpdateStatusLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addComponent(cBoxSttPay, 0, 235, Short.MAX_VALUE)
                    .addComponent(txtBillId))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 18, Short.MAX_VALUE)
                .addComponent(btnShowBill)
                .addContainerGap())
        );
        jpUpdateStatusLayout.setVerticalGroup(
            jpUpdateStatusLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jpUpdateStatusLayout.createSequentialGroup()
                .addGap(20, 20, 20)
                .addGroup(jpUpdateStatusLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel1)
                    .addComponent(txtBillId, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(btnShowBill))
                .addGap(18, 18, 18)
                .addComponent(cBoxSttPay, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 28, Short.MAX_VALUE)
                .addComponent(btnUpdatePay)
                .addContainerGap())
        );

        javax.swing.GroupLayout itnfStatusTTLayout = new javax.swing.GroupLayout(itnfStatusTT.getContentPane());
        itnfStatusTT.getContentPane().setLayout(itnfStatusTTLayout);
        itnfStatusTTLayout.setHorizontalGroup(
            itnfStatusTTLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(itnfStatusTTLayout.createSequentialGroup()
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addComponent(jpUpdateStatus, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(34, 34, 34)
                .addComponent(jpTotal, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(40, 40, 40))
            .addGroup(itnfStatusTTLayout.createSequentialGroup()
                .addGap(24, 24, 24)
                .addComponent(jpStatus, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addContainerGap())
        );
        itnfStatusTTLayout.setVerticalGroup(
            itnfStatusTTLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(itnfStatusTTLayout.createSequentialGroup()
                .addComponent(jpStatus, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(itnfStatusTTLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addComponent(jpUpdateStatus, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(jpTotal, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addContainerGap(30, Short.MAX_VALUE))
        );

        jpUpdateStatus.getAccessibleContext().setAccessibleName("Change pay Status");

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(itnfStatusTT, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(itnfStatusTT)
        );

        pack();
    }// </editor-fold>//GEN-END:initComponents

    private void btnViewActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnViewActionPerformed
        // TODO add your handling code here:
        String i = (String) cBoxStt.getSelectedItem();
        if ("All".equalsIgnoreCase(i)) {
            a.ShowTable(tableListBill, "", "Waybill", "Date", "StatusTT", "StatusVH", "EmployeeIDGN", "EmployeeIDKT", (String) cBoxDay.getSelectedItem(), (String) cBoxMonth.getSelectedItem(), (String) cBoxYear.getSelectedItem());
        } else {
            a.ShowTable(tableListBill, "Where StatusTT='" + i + "'", "Waybill", "Date", "StatusTT", "StatusVH", "EmployeeIDGN", "EmployeeIDKT", (String) cBoxDay.getSelectedItem(), (String) cBoxMonth.getSelectedItem(), (String) cBoxYear.getSelectedItem());
        }
    }//GEN-LAST:event_btnViewActionPerformed

    private void txtBillIdActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_txtBillIdActionPerformed
        // TODO add your handling code here:
    }//GEN-LAST:event_txtBillIdActionPerformed

    private void btnUpdatePayActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnUpdatePayActionPerformed
        // TODO add your handling code here:
        int sttchange = cBoxSttPay.getSelectedIndex();
        String idChange = txtBillId.getText();
        String st = null;

        try {
            ConnectSQL con = new ConnectSQL();

            if (sttchange == 0) {
                st = "UPDATE List_VotesSent SET StatusTT='Unpaid', EmployeeIDKT='" + s.GetID(Interface.EN, "Employee") + "' WHERE Waybill='" + idChange + "'";
            }
            if (sttchange == 1) {
                st = "UPDATE List_VotesSent SET StatusTT='Completed', EmployeeIDKT='" + s.GetID(Interface.EN, "Employee") + "' WHERE Waybill='" + idChange + "'";
            }
            con.updateData(st);
            String i = (String) cBoxStt.getSelectedItem();
            if ("All".equalsIgnoreCase(i)) {
                a.ShowTable(tableListBill, "", "Waybill", "Date", "StatusTT", "StatusVH", "EmployeeIDGN", "EmployeeIDKT", (String) cBoxDay.getSelectedItem(), (String) cBoxMonth.getSelectedItem(), (String) cBoxYear.getSelectedItem());
            } else {
                a.ShowTable(tableListBill, "Where StatusTT='" + i + "'", "Waybill", "Date", "StatusTT", "StatusVH", "EmployeeIDGN", "EmployeeIDKT", (String) cBoxDay.getSelectedItem(), (String) cBoxMonth.getSelectedItem(), (String) cBoxYear.getSelectedItem());
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }//GEN-LAST:event_btnUpdatePayActionPerformed

    private void cBoxDayActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cBoxDayActionPerformed
        // TODO add your handling code here:
    }//GEN-LAST:event_cBoxDayActionPerformed

    private void tableListBillMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_tableListBillMouseClicked
        // TODO add your handling code here:
        txtBillId.setText((String) tableListBill.getValueAt(tableListBill.getSelectedRow(), 0));
    }//GEN-LAST:event_tableListBillMouseClicked

    private void cBoxMonthActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cBoxMonthActionPerformed
        // TODO add your handling code here:
        int a = cBoxMonth.getSelectedIndex();
        if (a == 0 || a == 2 || a == 4 || a == 6 || a == 7 || a == 9 || a == 11) {
            for (; cBoxDay.getItemCount() != 31;) {
                cBoxDay.addItem(cBoxDay.getItemCount() + 1);
            }
        }
        if (a == 1) {
            for (; cBoxDay.getItemCount() != 29;) {
                cBoxDay.removeItemAt(cBoxDay.getItemCount() - 1);
            }
        }
        if (a == 3 || a == 5 || a == 8 || a == 10) {
            for (; cBoxDay.getItemCount() != 33;) {
                int i = cBoxDay.getItemCount() + 1;
                cBoxDay.addItem(i);
            }
            for (; cBoxDay.getItemCount() != 31;) {
                cBoxDay.removeItemAt((cBoxDay.getItemCount() - 1));
            }

        }

    }//GEN-LAST:event_cBoxMonthActionPerformed

    private void cBoxYearActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cBoxYearActionPerformed
        // TODO add your handling code here:

        int x = (int) cBoxYear.getSelectedItem();

        if (x % 4 == 0) {
            int y = cBoxMonth.getSelectedIndex();
            if (y == 1) {
                for (; cBoxDay.getItemCount() != 29;) {
                    cBoxDay.removeItemAt(cBoxDay.getItemCount() - 1);
                }
            }


        }
    }//GEN-LAST:event_cBoxYearActionPerformed

    private void btnShowBillActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnShowBillActionPerformed
        // TODO add your handling code here:
        EB = "Where Waybill='" + txtBillId.getText() + "'";
        new Show_VotesSent().setVisible(true);
    }//GEN-LAST:event_btnShowBillActionPerformed

    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        /*
         * Set the Nimbus look and feel
         */
        //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
        /*
         * If Nimbus (introduced in Java SE 6) is not available, stay with the
         * default look and feel. For details see
         * http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
         */
        try {
            for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
                if ("Nimbus".equals(info.getName())) {
                    javax.swing.UIManager.setLookAndFeel(info.getClassName());
                    break;
                }
            }
        } catch (ClassNotFoundException ex) {
            java.util.logging.Logger.getLogger(Enquiry.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(Enquiry.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(Enquiry.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(Enquiry.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        }
        //</editor-fold>

        /*
         * Create and display the form
         */
        java.awt.EventQueue.invokeLater(new Runnable() {

            public void run() {
                new Enquiry().setVisible(true);
            }
        });
    }
    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JButton btnShowBill;
    private javax.swing.JButton btnUpdatePay;
    private javax.swing.JButton btnView;
    private javax.swing.JComboBox cBoxDay;
    private javax.swing.JComboBox cBoxMonth;
    private javax.swing.JComboBox cBoxStt;
    private javax.swing.JComboBox cBoxSttPay;
    private javax.swing.JComboBox cBoxYear;
    private javax.swing.JInternalFrame itnfStatusTT;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JScrollPane jSPTable;
    private javax.swing.JPanel jpStatus;
    private javax.swing.JPanel jpTotal;
    private javax.swing.JPanel jpUpdateStatus;
    private javax.swing.JTable tableListBill;
    private javax.swing.JTextField txtBillId;
    private javax.swing.JTextField txtBills;
    private javax.swing.JTextField txtMoney;
    // End of variables declaration//GEN-END:variables
}
